<?php

/**
 * 404 actions.
 *
 * @package    e-DSL
 * @subpackage 404
 * @author     Your name here
 * @version    SVN: $Id: actions.class.php 12474 2008-10-31 10:41:27Z fabien $
 */
class fichiersActions extends sfActions
{
  public function executeIndex(sfWebRequest $request){
	unset($_SESSION['inform']);
  	
	$q = Doctrine_Query::create()
    ->select('f.*')
    ->from('fichierdef f, categoriedossier c, typedossier t')
    ->where('f.categoriedossier_id = c.id')
    ->addWhere('c.typedossier_id = t.id')
    ->orderBy('t.description, f.categoriedossier_id, f.description');


	$this->fichiers = $q->execute();
	
  }
}